package com.xmy.cultivate.mapper;

import com.xmy.cultivate.entity.StudentClassType;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author hpiggy
 * @since 2023-09-04
 */
public interface StudentClassTypeMapper extends BaseMapper<StudentClassType> {

    @Select("select * from student_class_type where year_part =${yearPart} and quarter_num =${quarterNum}  and subjects_id =${subjectsId} and student_id =${studentId} limit 1")
    public StudentClassType getOneForYearPart(@Param("yearPart") Integer yearPart,@Param("quarterNum") Integer quarterNum,@Param("subjectsId") Long subjectsId,@Param("studentId") Long studentId);

}
